002
SELECT contentDB.contentID,contentDB.bookID,contentDB.sceneID,contentDB.mediaType,contentDB.mediaInfo,contentDB.webAllowed,contentDB.webAllowed2,contentDB.clientAllowed,contentDB.dvdAllowed,contentDB.tbProd,contentDB.type,contentDB.sceneType,contentDB.dateAdded,contentDB.name,contentDB.prodNotes,contentDB.prodDate,contentDB.backup,contentDB.story,contentDB.nickname,contentDB.folderName,contentDB.fileID,contentDB.searchKeys,contentDB.extURL,contentDB.cgID,contentDB.schedSeq,contentDB.picsComplete,contentDB.picsUploaded,contentDB.vidsUploaded,contentDB.vidsComplete,contentDB.contentNotes,contentDB.dueDate,contentDB.x2257,contentDB.captured,contentDB.dvdID,contentDB.pics,contentDB.vids,contentDB.recieved,contentDB.recDate,contentDB.shipped,contentDB.shipDate,contentDB.note1,siteScenes.ssID,siteScenes.siteID,siteScenes.contentID,siteScenes.sceneNum,siteScenes.status,siteScenes.schedStart,siteScenes.schedEnd,siteScenes.story,siteScenes.short,siteScenes.nickname,siteScenes.currentlyFeat,siteScenes.oemFeat,siteScenes.promotional,siteScenes.onSale,siteScenes.dateAdded,siteScenes.pageClass,siteScenes.wmView,siteScenes.lockClass,siteScenes.totalClicks,siteScenes.resClicks,siteScenes.avgClicks,siteScenes.votes FROM contentDB,siteScenes WHERE contentDB.contentID=siteScenes.contentID AND contentDB.contentID IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,18,19,21,22,23,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,60,61,62,63,64,75,76,77,78,84,85,91,92,93,100,101,102,103,104,112,113,115,116,119,120,122,125,126,130,131,132,133,137,138,140,142,156,157,159,166,170,176,180,184,185,186,190,192,196,202,203,205,206,207,211,212,214,218,219,220,221,244,245,246,247,248,249,250,251,257,258,259,269,271,272,273,274,278,279,283,284,286,287,290,291,292,293,294,295,296,297,299,304,306,308,310,312,313,314,315,316,334,344,345,347,348) AND siteScenes.status='active' AND contentDB.mediaType=1 AND contentDB.cgID IN (1) AND contentDB.cgID>0 ORDER BY siteScenes.schedStart desc LIMIT -1,8
simpleQuery("contentDB,siteScenes","contentDB.contentID,contentDB.bookID,contentDB.sceneID,contentDB.mediaType,contentDB.mediaInfo,contentDB.webAllowed,contentDB.webAllowed2,contentDB.clientAllowed,contentDB.dvdAllowed,contentDB.tbProd,contentDB.type,contentDB.sceneType,contentDB.dateAdded,contentDB.name,contentDB.prodNotes,contentDB.prodDate,contentDB.backup,contentDB.story,contentDB.nickname,contentDB.folderName,contentDB.fileID,contentDB.searchKeys,contentDB.extURL,contentDB.cgID,contentDB.schedSeq,contentDB.picsComplete,contentDB.picsUploaded,contentDB.vidsUploaded,contentDB.vidsComplete,contentDB.contentNotes,contentDB.dueDate,contentDB.x2257,contentDB.captured,contentDB.dvdID,contentDB.pics,contentDB.vids,contentDB.recieved,contentDB.recDate,contentDB.shipped,contentDB.shipDate,contentDB.note1,siteScenes.ssID,siteScenes.siteID,siteScenes.contentID,siteScenes.sceneNum,siteScenes.status,siteScenes.schedStart,siteScenes.schedEnd,siteScenes.story,siteScenes.short,siteScenes.nickname,siteScenes.currentlyFeat,siteScenes.oemFeat,siteScenes.promotional,siteScenes.onSale,siteScenes.dateAdded,siteScenes.pageClass,siteScenes.wmView,siteScenes.lockClass,siteScenes.totalClicks,siteScenes.resClicks,siteScenes.avgClicks,siteScenes.votes","WHERE contentDB.contentID=siteScenes.contentID AND contentDB.contentID IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,18,19,21,22,23,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,60,61,62,63,64,75,76,77,78,84,85,91,92,93,100,101,102,103,104,112,113,115,116,119,120,122,125,126,130,131,132,133,137,138,140,142,156,157,159,166,170,176,180,184,185,186,190,192,196,202,203,205,206,207,211,212,214,218,219,220,221,244,245,246,247,248,249,250,251,257,258,259,269,271,272,273,274,278,279,283,284,286,287,290,291,292,293,294,295,296,297,299,304,306,308,310,312,313,314,315,316,334,344,345,347,348) AND siteScenes.status='active' AND contentDB.mediaType=1 AND contentDB.cgID IN (1) AND contentDB.cgID>0","ORDER BY siteScenes.schedStart desc LIMIT -1,8")
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1,8' at line 1